yii2中restful url访问配置， 登陆接口access

/* Navicat MySQL Data Transfer

Source Server : localhost Source Server Version : 50553 Source Host : localhost:3306 Source Database : oauth2

Target Server Type : MYSQL Target Server Version : 50553 File Encoding : 65001

Date: 2017-01-16 13:57:48 */

SET FOREIGN_KEY_CHECKS=0;

-- Table structure for mxq_guide

DROP TABLE IF EXISTS mxq_guide; CREATE TABLE mxq_guide (id int(11) NOT NULL,imgurl varchar(255) DEFAULT NULL,status smallint(2) DEFAULT NULL,flag smallint(2) DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Records of mxq_guide

INSERT INTO mxq_guide VALUES ('0', 'ddd', '1', '1111'); INSERT INTO mxq_guide VALUES ('2', 'ssss', '1', '2222'); INSERT INTO mxq_guide VALUES ('3', '555', '4', '444');

-- Table structure for user

DROP TABLE IF EXISTS user; CREATE TABLE user (id int(20) unsigned NOT NULL AUTO_INCREMENT,username varchar(50) DEFAULT NULL COMMENT '用户名',password_hash varchar(80) DEFAULT NULL COMMENT '密码',password_reset_token varchar(60) DEFAULT NULL COMMENT '密码token',email varchar(60) DEFAULT NULL COMMENT '邮箱',auth_key varchar(60) DEFAULT NULL,status int(5) DEFAULT NULL COMMENT '状态',created_at int(18) DEFAULT NULL COMMENT '创建时间',updated_at int(18) DEFAULT NULL COMMENT '更新时间',password varchar(50) DEFAULT NULL COMMENT '密码',role varchar(50) DEFAULT NULL COMMENT 'role',curr_login_at varchar(50) DEFAULT NULL,curr_login_ip varchar(50) DEFAULT NULL,access_token varchar(60) DEFAULT NULL,login_count varchar(50) DEFAULT NULL,allowance int(20) NOT NULL,allowance_updated_at int(20) NOT NULL, PRIMARY KEY (id), UNIQUE KEY username (username), UNIQUE KEY access_token (access_token) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- Records of user

INSERT INTO user VALUES ('1', 'terry', '$2y$07$BCryptRequires22Chrcte/VlQH0piJtjXl.0t1XkA8pw9dMXTpOq', null, '[email protected]', 'pBJi3hyFsLsTuvUM9paFpWjYRatn3qwS', '10', '1441763620', '1484546128', null, null, '1484235121', '::1', 'qvuhh01lt4Q4GZnnLI2gdL1HwYR0nLWN', '17', '0', '1447318986'); INSERT INTO user VALUES ('2', 'terry1', '$2y$07$BCryptRequires22Chrcte/VlQH0piJtjXl.0t1XkA8pw9dMXTpOq', null, '[email protected]', 'wIvJk7dMm6PQ1dJFz8iUqJ1RfH6rsDTW', '10', '1441763906', '1484235959', null, null, '1484235121', '::1', '_ydI-L1lQQwKZzoOWzMOUjMZ-t1PcM4k', '2', '0', '0'); INSERT INTO user VALUES ('3', 'zqy', '$2y$07$BCryptRequires22Chrcte/VlQH0piJtjXl.0t1XkA8pw9dMXTpOq', null, '[email protected]', 'K-76pcy7gxceemxRI2IeN5g1EhLMaCj8', '10', '1442544183', '1442544183', null, 'moderator', null, null, null, null, '0', '0'); INSERT INTO user VALUES ('4', 'admin', '$2y$07$BCryptRequires22Chrcte/VlQH0piJtjXl.0t1XkA8pw9dMXTpOq', null, '[email protected]', 'hZWOaamjHEsPtuJJVghFRdE2oTj7Qv8P', '10', '1446524232', '1446524232', null, null, null, null, null, null, '0', '0');

数据库